*** Emailing from Win32 VBA Applications *** This file explains how to email from Office 97 VBA applications, such as EXCEL 97, ACCESS 97, and WORD 97. (1) Start EXCEL 97 (or other Office 97 program). (2) Enter design mode. You may have to enable the "Controls Toolbox" first. Choose "Tools" on the menu bar, then "Customize", and then check the "Control Toolbox". (3) From the control toolbox, choose and position the "Command Button". This will create code that looks like Private Sub CommandButton1_Click() End Sub (4) Replace the generated code with MODULE32.BAS. The easiest way to do this is to paste from the clipboard. (5) Edit the strings SmtpServer, SmtpFrom, and SmtpTo which appear in MODULE32.BAS with your email settings. Don't forget to enclose all email addresses within "<>" brackets. (6) Exit design mode, and run your application.